<?php require 'header.php';?>
<?php
$magv=$UserDN;
$sql1="SELECT NienKhoa FROM dbo_monhoc, dbo_kehoachhoithao WHERE dbo_monhoc.MaMH=dbo_kehoachhoithao.MaMH ";
$sql1.=" GROUP BY NienKhoa";
$stmt = $db->prepare($sql1);
$stmt->execute();

$sql2="SELECT dbo_monhoc.MaMH, TenMH, NienKhoa FROM dbo_kehoachhoithao, dbo_monhoc";
$sql2.=" WHERE dbo_kehoachhoithao.MaMH=dbo_monhoc.MaMH";
$stmt1 = $db->prepare($sql2);
$stmt1->execute();

$sql3="SELECT dbo_giangvien.MaGV,Holot, Ten FROM dbo_giangvien WHERE dbo_giangvien.MaGV=:magv";
$stmt2 = $db->prepare($sql3);
$stmt2->bindParam(":magv",$magv,PDO::PARAM_STR);
$stmt2->execute();
$r3=$stmt2->fetch();
?>
  <script>
  $(function() {
    $( "#tabs-khht" ).tabs();
  });
  </script>
</head>
<body>
 <div class="panel panel-primary">
	<div class="panel-heading" id="canhgiua" >KẾ HOẠCH HỌC TẬP</div>
	<div class="panel-body">
<div id="tabs-khht">
  <ul>
    <li><a href="#tabs-1">Qui định tổ chức hội thao</a></li>
    <li><a href="#tabs-2">Thông tin kế hoạch tổ chức</a></li>
    <li><a href="#tabs-khhhk">Tổ chức hội thi</a></li>
  </ul>
  <div id="tabs-1">
    <?php include 'thongtinkehoachhoctap.php';?>
  </div>
  <div id="tabs-2">
    <?php include 'kehoachhoctaptoankhoa.php'; ?>
  </div>
    <div id="tabs-khhhk">
    <?php include 'kehoachhoctaptheohocky.php'; ?>
    </div>
    
</div>
</div>
</div>
</body>
<?php require 'footer.php'; ?>
